Committeemen Characteristics
To create a pie chart showing the relative size of each category of Salem Village's committeemen, open a new worksheet. Using the data in the committeemen pivot table, label each column with one of the five groups of committeemen (Anti-P Church Member, Anti-P Householder, Pro-P Church Member, Pro-P Householder, and NoS Householder). Since the one anti-Parris freeholder is likely a member of a church other than Salem Village's, he has been included with the Anti-P Church Member group.
Anti-P Church | Anti-P Householder | Pro-P Church | Pro-P Householder | NoS Householder |
5 | 10 | 10 | 3 | 3 |
Drag through the two rows to select them. Open the Chart Wizard. Choose "Pie": the two rows of cells are identified in the "Data Range" window. The Rows button must be selected, indicating "series in" rows. The pie chart (see above) can be edited in the Chart Options window and, in the completed chart, by right-clicking the labels and selecting "Format Data Labels." Users can, for example, present the data as percentages rather than numbers.
The chart illustrates the importance of church membership among pro-Parris committeemen as well as the association of non-church membership (householders) to anti-Parris committeemen. Since committee membership and church membership were both associated with high social standing in a community, it is not surprising to find a significant minority church members in the anti-Parris political leadership. Still, the preponderance of anti-Parris householders remains striking.
To return to the Committeemen Social Report page, click Back or Next.